"""
select
    Department.name as 'Department',
    a.name as 'Employee',
    a.salary as 'Salary'
from
(select
    *, dense_rank() over(partition by departmentId order by salary desc) as 'rank'
from
    Employee)  as a left join Department
on
    a.departmentId = Department.id
where
    a.rank = 1
"""